SELECT *, CASE WHEN `name` LIKE "little river%" AND `sub_cat` IS NULL AND `cat` IS NULL AND `locality` = "little river" AND `logo_file_name` IS NOT NULL THEN 10 WHEN `sub_cat` IS NULL AND `cat` IS NULL AND `locality` = "little river" AND `logo_file_name` IS NOT NULL THEN 2 WHEN `sub_cat` IS NULL AND `cat` IS NULL AND `locality` = "little river" AND `logo_file_name` IS NULL THEN 1 WHEN `sub_cat` IS NULL AND `cat` IS NULL AND `locality` IS NULL AND `logo_file_name` IS NULL THEN 0 END as `rank` FROM `wp_slides` WHERE st = "SC" AND (locality IN ("little river") OR locality IS NULL) AND (cat IS NULL) AND name NOT IN ("home-top", "home-bot") AND (slide_file_name IS NOT NULL AND slide_file_name != "") AND (slide_location IS NULL OR slide_location = "") AND name NOT IN ("agent") AND active = 1 ORDER BY `rank` DESC LIMIT 12
[0] matching rows / [0.00 msec]
Blog ID 30
Blah
SELECT *, "0" as `rank` FROM `wp_slides` WHERE st = "SC" AND (cat IS NULL) AND (slide_file_name IS NOT NULL AND slide_file_name != "") AND (slide_location IS NULL OR slide_location = "") AND active = 1 ORDER BY `rank` DESC LIMIT 12
[0] matching rows / [0.00 msec]
Blog ID 30
Blah
Get email when new and updated listings match this saved search.
Get email when newly sold listings match this saved search.
Save Search
Delete Shape
Click on these drawing tools to draw shapes to contain listings. You can save these shapes as a Saved Search.
$2,995,0004806 Williams Island DrLittle River SC 29566View Listing
$2,200,0004852 Williams Island Dr Unit ParadiseLittle River SC 29566View Listing
$2,099,9994818 Williams Island Dr Unit ParadiseLittle River SC 29566View Listing
$1,300,000106 Serenity Point Unit-Birds of Paradise Dr Lot 15Little River SC 29566View Listing
$1,300,000132 Serenity Point Dr Pt Unit SerenityLittle River SC 29566View Listing
$1,299,900112 Waterway Crossing CtLittle River SC 29566View Listing
$1,249,9004013 Thomas RdLittle River SC 29566View Listing
$1,004,0982263 Spanish Moss CtLittle River SC 29566View Listing
$1,000,000130 Pier Pointe DrLittle River SC 29566View Listing
$999,000139 Pier Pointe DrLittle River SC 29566View Listing
$849,0002278 Big Landing DrLittle River SC 29566View Listing
$797,5283170 White Jasmine Dr Unit Lakeview-Sun Dial G Ests Lot 88Little River SC 29566View Listing
$755,1111223 Colusa Unit W5-Goldenrod Ct Lot 142Little River SC 29566View Listing
$710,1593150 White Jasmine Dr Unit Lakeview Sandcastle G Ests Lot 93Little River SC 29566View Listing
$706,2903154 White Jasmine Dr Unit Lakeview Sea Star F Ests Lot 92Little River SC 29566View Listing
$679,7073186 White Jasmine Dr Unit Lakeview-Sun Dial A Ests Lot 84Little River SC 29566View Listing
$674,6481487 Breakwater Dr-Seashore B Vlg Unit ShorehavenLittle River SC 29566View Listing
$670,8231936 Woodrush Unit Shorehaven 4-Surfrider A Loop Lot 23Little River SC 29566View Listing
$669,9001205 Colusa Unit-Goldenrod K Ct Lot 138GRANDVIEWLittle River SC 29566View Listing
$661,2021906 Woodrush Unit Shorehaven 4-Seashore A Loop Lot 29Little River SC 29566View Listing
$657,3921928 Woodrush Loop Unit Shorehaven-Sand Dollar A Vlg Lot 25Little River SC 29566View Listing
The data relating to real estate for sale on this site comes from ListHub. All properties are subject to prior sale, changes, or withdrawal. This site was last updated May-09-2024 5:20:58 am.
SELECT *, "0" as `rank` FROM `wp_slides` WHERE st = "SC" AND (cat = "lenders" OR cat IS NULL) AND (slide_file_name IS NOT NULL AND slide_file_name != "") AND (slide_location IS NULL OR slide_location = "") AND active = 1 ORDER BY `rank` DESC LIMIT 12
[0] matching rows / [0.00 msec]
Blog ID 30
Blah